<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Evaluating qualifications at the report or grid level</title>
<link rel="stylesheet" href="RoboHTML_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='RoboHTML.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Analyzing report and document results\nRestricting report results: Filtering\nEvaluating qualifications at the report or grid level");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Evaluating qualifications at the report or grid level</h1>
<p>When a metric qualification in a view filter is evaluated by the system, 
 the evaluation can be performed for all data that is returned for the 
 report, or only the view of data that is currently available on the report 
 grid. These two options can produce different report results when using 
 the OLAP Services feature called dynamic aggregation. </p>
<p>By default, metric qualifications in a view filter are evaluated at 
 the level of data that is available on the report grid. This means that 
 any attributes that are included in the Report Objects pane but not on 
 the report grid are not used to determine the level of the metric qualification. 
 </p>
<p>The following information should be taken into consideration when choosing 
 an evaluation level for a metric qualification. This information assumes 
 you are familiar with report levels as explained in the <span style="font-style: italic;"><I>MicroStrategy 
 Advanced Reporting Guide</I></span>.</p>
<ul>
<li class=P-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
	
<li class=P-Topic-Text-Bulleted><p class=Topic-Text-Bulleted><span 
 style="font-weight: bold;"><B>Evaluation at the report grid level</B></span>: 
 Evaluating metric qualifications at the level present on the report grid 
 allows the view filter to dynamically display analysis that reflects the 
 data available on the report grid. If all attributes are on the report 
 grid, then this level is used to calculate the metric qualification. Additionally, 
 anytime an attribute is moved between the Report Objects pane and the 
 report grid, the view filter dynamically recalculates the metric qualification 
 to reflect the new level of data on the report grid.<br>

	<br>

	If derived metrics are also on this report, evaluating metric qualifications 
 at the grid level also causes the metric qualifications to be evaluated 
 after derived metrics by default. This means that these qualifications 
 filter the results of any derived metric calculations. For more information, 
 see the <span style="font-style: italic;"><I>MicroStrategy Advanced Reporting 
 Guide. </I></span></p></li>
</ul>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted><span 
 style="font-weight: bold;"><B>Evaluation at the report level</B></span>: Evaluating 
 metric qualifications at the report level regardless of what attributes 
 are on the report grid or the Report Objects pane provides a consistent 
 level of analysis during dynamic aggregation. <br>

	<br>

	If derived metrics are also on this report, evaluating metric qualifications 
 at the report level also causes the metric qualifications to be evaluated 
 before derived metrics by default. This means that these qualifications 
 filter data before any derived metric calculations are applied. For more 
 information, see the <span style="font-style: italic;"><I>MicroStrategy Advanced 
 Reporting Guide</I></span><span style="font-style: italic;"><I>.</I></span></p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted><span 
 style="font-weight: bold;"><B>Metric-to-metric qualifications</B></span>: The 
 evaluation level of metric-to-metric qualifications cannot be modified. 
 All metric-to-metric qualifications are evaluated at the report level. 
 For information on metric-to-metric qualifications, see the <span style="font-style: italic;"><I>MicroStrategy 
 Advanced Reporting Guide.</I></span></p></li>
</ul>
<p>The steps below show you how to modify the evaluation of metric qualifications 
 in a view filter.</p>
<h2>Prerequisites</h2>
<ul>
<li class=P-First-Bullet-Do-Not-Type-Text><p class=First-Bullet-Do-Not-Type-Text>&nbsp;</p></li>
</ul>
<ul>
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>You need 
 the Web Use View Filter Editor privilege. This privilege is part of OLAP 
 Services. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>A report 
 with a metric qualification in the view filter that is not a metric-to-metric 
 qualification. </p></li>
	
<li class=p-Topic-Text-Bulleted><p class=Topic-Text-Bulleted>To observe 
 how this modification can affect report results, the report should also 
 have some attributes in the Report Objects, but not on the report grid.<span 
 style="font-weight: bold;"> <B><br>

	<br>

	Warning</B></span>: You cannot modify the evaluation level of metric-to-metric 
 qualifications. All metric-to-metric qualifications are evaluated at the 
 report level. </p></li>
</ul>
<h2>To modify the evaluation level of metric qualifications in a view filter</h2>
<ol>
<li class=P-Steps><p class=Steps>Log in to a project in MicroStrategy 
 Web. </p></li>
	
<li class=P-Steps><p class=Steps>Run a report in Grid View. </p></li>
	
<li class=P-Steps><p class=Steps>If the View Filter area is not displayed, 
 from the <span style="font-weight: bold;"><B>Tools</B></span> menu, select <span 
 style="font-weight: bold;"><B>View Filter</B></span>. </p></li>
	
<li class=P-Steps><p class=Steps>In the<span style="font-weight: bold;"><B> 
 View Filter</B></span> area, right-click a metric qualification and select 
 one of the following options, which you can switch between:</p></li>
</ol>
<ol type="disc" class="whs1">
	<ul>
<li class=P-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Apply 
 Condition at the Grid Level </B></span>(default): Evaluates the metric qualification 
 only for the attributes included on the report grid. Attributes in the 
 Report Objects pane but not on the report grid are not included in the 
 metric qualification evaluation.</p></li>
		
<li class=P-Steps-Bulleted-1><p class=Steps-Bulleted-1><span style="font-weight: bold;"><B>Apply 
 Condition at the {</B></span><span style="font-weight: bold; font-style: italic;"><I><B>attributes 
 in Report Objects</B></I></span><span style="font-weight: bold;"><B>} Level</B></span>: 
 Evaluates the metric qualification for all attributes included in the 
 Report Objects pane, regardless of whether they are displayed on the report 
 grid.<span style="font-weight: bold;"><B><br>

		<br>

		Note</B></span>: You can choose different evaluation options for separate 
 metric qualifications in the same view filter. </p></li>
	</ul>
</ol>
<ol start=5>
<li class=P-Steps><p class=Steps>If the Auto-Apply Changes 
 check box is cleared, click <span style="font-weight: bold;"><B>Apply</B></span> 
 to apply the view filter to the report. </p></li>
</ol>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
